Tabela CNTrackingInfo

Definicja tabeli CNTrackingInfo

Name

CNTrackingInfo

Code

CNTrackingInfo

Comment

 


Lista kolumn tabeli CNTrackingInfo

Name

Code

CNTrackingInfoID

CNTrackingInfoID

OrderID

OrderID

IdentifierTypeID

IdentifierTypeID

ExternalValue

ExternalValue

DateValue

DateValue

OrderingOrgUnit

OrderingOrgUnit

OrderingPerson

OrderingPerson

Location

Location

Reason

Reason

GivingArchivist

GivingArchivist

TakingPersonnel

TakingPersonnel

StartDT

StartDT

TakingArchivist

TakingArchivist

GivingPersonnel

ReturningPersonnel

StopDT

StopDT

ExpectedStopDT

ExpectedStopDT

Comments

Comments

BorrowingComments

BorrowingComments


Kolumna CNTrackingInfoID tabeli CNTrackingInfo

Definicja kolumny CNTrackingInfoID tabeli CNTrackingInfo

Name

CNTrackingInfoID

Code

CNTrackingInfoID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OrderID tabeli CNTrackingInfo

Definicja kolumny OrderID tabeli CNTrackingInfo

Name

OrderID

Code

OrderID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IdentifierTypeID tabeli CNTrackingInfo

Definicja kolumny IdentifierTypeID tabeli CNTrackingInfo

Name

IdentifierTypeID

Code

IdentifierTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalValue tabeli CNTrackingInfo

Definicja kolumny ExternalValue tabeli CNTrackingInfo

Name

ExternalValue

Code

ExternalValue

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna DateValue tabeli CNTrackingInfo

Definicja kolumny DateValue tabeli CNTrackingInfo

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna OrderingOrgUnit tabeli CNTrackingInfo

Definicja kolumny OrderingOrgUnit tabeli CNTrackingInfo

Name

OrderingOrgUnit

Code

OrderingOrgUnit

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingPerson tabeli CNTrackingInfo

Definicja kolumny OrderingPerson tabeli CNTrackingInfo

Name

OrderingPerson

Code

OrderingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Location tabeli CNTrackingInfo

Definicja kolumny Location tabeli CNTrackingInfo

Name

Location

Code

Location

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Reason tabeli CNTrackingInfo

Definicja kolumny Reason tabeli CNTrackingInfo

Name

Reason

Code

Reason

Data Type

VARCHAR2(268)

Mandatory

No

Comment

 


Kolumna GivingArchivist tabeli CNTrackingInfo

Definicja kolumny GivingArchivist tabeli CNTrackingInfo

Name

GivingArchivist

Code

GivingArchivist

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TakingPersonnel tabeli CNTrackingInfo

Definicja kolumny TakingPersonnel tabeli CNTrackingInfo

Name

TakingPersonnel

Code

TakingPersonnel

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli CNTrackingInfo

Definicja kolumny StartDT tabeli CNTrackingInfo

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna TakingArchivist tabeli CNTrackingInfo

Definicja kolumny TakingArchivist tabeli CNTrackingInfo

Name

TakingArchivist

Code

TakingArchivist

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GivingPersonnel tabeli CNTrackingInfo

Definicja kolumny GivingPersonnel tabeli CNTrackingInfo

Name

GivingPersonnel

Code

ReturningPersonnel

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StopDT tabeli CNTrackingInfo

Definicja kolumny StopDT tabeli CNTrackingInfo

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna ExpectedStopDT tabeli CNTrackingInfo

Definicja kolumny ExpectedStopDT tabeli CNTrackingInfo

Name

ExpectedStopDT

Code

ExpectedStopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Comments tabeli CNTrackingInfo

Definicja kolumny Comments tabeli CNTrackingInfo

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna BorrowingComments tabeli CNTrackingInfo

Definicja kolumny BorrowingComments tabeli CNTrackingInfo

Name

BorrowingComments

Code

BorrowingComments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli CNTrackingInfo

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli CNTrackingInfo

Definicja klucza Identifier_1 tabeli CNTrackingInfo

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment